SAP BO

1. OLTP vs. OLAP

2. Types of OLAP

3. Multi Dimensional Modeling Of SAP BW 7.3

4. SAP BW 7.3 Cubes, DSO’s ,Multi Providers, Infosets

5. Business Explorer (Bex) Queries in BW 7.3 system as Data sources

6. Data Flow in BW 7.3 and Activating Business Content Cube.

1. Joins & Cardinality

2. Views/Materialized Views

3. Date/Time Functions

1. Architectural overview

2. Client tier components

3. Application tier components

4. Intelligence tier

5. Processing tier

6. Data tier

7. Security management

8. Information

1. Understanding Business Objects Universes

2. Creating the Course Universe

3. Building the Universe Structure

4. Creating Dimension Objects

5. Creating Measure Objects

6. Resolving Loops in a Universe

7. Resolving SQL Traps

8. Using List of Values

9. Applying Restrictions on Objects

10. Using @Functions with Objects

11. Using Hierarchies

12. Deriving Tables & Indexes

13. Working with Aggregate Awareness

14. Designing Advanced Objects

15. Creating Predefined Condition

16. LOVs & Joins

17. Securing Universes

18. Implementing Universe Life Cycle Mgmt

19. Maintaining & Optimizing Universes

20. Creating Universe from Other Data sources

1. Understand concepts of Web intelligence

2. Create Web Intelligence documents with Queries

3. Restrict data returned by a query

4. Design a report

5. Enhance the presentation of data in reports

6. Creation of Web intelligence report with auto scheduling

7. Creation of Corporate dashboard for Supply chain mgmt/Banking Domain

8. Format a report

9. Calculate data with formulas and variables

10. Use multiple data sources

11. Analyze data

12. Manage and share Web Intelligence documents

13. Work with Advanced Query techniques

14. Work with calculation contexts

15. Create formulas with character & date string functions

16. Use “If” logic

17. Work with additional reporting techniques

18. Create hyperlinks

1. Planning a Report

2. Selecting Records

3. Formatting a Report

4. Representing Data Visually

5. Distributing Reports

6. Creating Basic Formulas

7. Organizing Data on a Report

8. Applying Section Formatting

9. Applying Conditional Reporting

10. Using the Repository

11. Using Report Templates

12. Creating Formulas

13. Building Parameterized Reports

14. Summarizing Data with Cross-Tabs

15. Using Report Sections

16. Managing Reports

17. Presenting Data Visually

18. Add hyperlinks to a report

1. Creating a Model

2. Adding Interactivity to a Model

3. Creating a Connected Model

4. Connect to Crystal Reports data and create Dashboard

5. Connect to Web intelligence report data and

6. Create Dashboard

7. Connect to Business Objects Universes

8. Using Query as a web service and create Dashboard

9. Use Live Office data and create Dashboard

10. Use other connectivity components and create Dashboard
Administration

1. Understand the Business Objects

2. Enterprise interface & architecture

3. Manage Business Objects Enterprise content

4. Secure Business Objects Enterprise content

5. Secure application security

6. Schedule content

7. Publish reports

8. Identify Business Objects Enterprise architecture

9. Perform common server management tasks

10. Manage the Business Objects Enterprise servers
Widgets

1. Installing BI Widgets

2. Using BI Widgets to Access BI Content

3. Working with widgets

4. BI Widgets Content Authoring Guidelines

5. Auto refresh of Widgets

1. Installing Web Intelligence Rich Client

2. Web Intelligence Rich Client working modes

3. Launching Web Intelligence Rich Client

4. To set user preferences in Web Intelligence Rich Client

5. Working with documents

6. Working with universes in Web Intelligence Rich Client

7. Accessing Web Intelligence from InfoView

8. Working with queries in Web Intelligence Rich Client

9. Working with reports

Universe Builder & Query Builder

1. Universe Builder basics

2. Building universes from XML metadata sources

3. Updating XML metadata source universes

4. Exporting a universe to a XML file format

1. Configuring the QWS with BO System

2. Creating Webservice report from Universes

3. Creating WSDL reports

4. Using WSDL reports in external application

1. Getting Started with Business Objects Voyager

2. Using Queries to Analyze Cube Data

3. Using Charts to Visualize Data

4. Selecting Members to Display in Crosstabs and Charts

5. Sorting, Filtering, and Ranking Data

6. Highlighting Exceptions in Data

7. Saving and Sharing Voyager Workspaces

1. Creating Secured users & group

2. Creation secured connections

3. Creation of Secured objects

4. Creation of security at Table, Column & row level

5. Creation of secured restriction set and mapping to users or groups

1. Creation of OLAP Universe by connecting to an Info cube

2. Updating the OLAP Universe (Cube)

3. Creating the Custom Hierarchies in OLAP Universes.

4. Accessing multiple info cubes to create an OLAP Universe

1. Using Import wizard

2. Creation of BIAR

3. Migrating the BO objects

4. From one CMS TO ANOTHER CMS

5. Migrating the objects from one

6. domain to another (dev/stage/Prod)

7. Backup & Maintenance Deployment

1. Creation of Semantic layer for Crystal reports

2. Creation of Dynamic list of values in Crystal reports

3. Creation of Cascading list of values in Crystal reports

4. Creating Data connection and Dynamic data connection

5. Creation of Data foundation

6. Creation of Business Element

7. Creation of Business View

8. Creation of LOV

9. Saving the Business view to repository

10. Accessing the Business View in Crystal reports using Database expert

11. Creation of Crystal reports using Business

12. View

13. Creation of Dashboard using Metric

14. Creating Performance dashboards using set analysis

1. Describe the benefits of using Live Office

2. Connect to the repository

3. Navigate the Live Office menu

4. Insert charts, crosstabs, and fields from a Crystal report

5. Insert report parts from a Web Intelligence document

6. Insert a new query based on a Universe

7. Insert Live Office objects into an email

8. Navigate and refresh Live Office objects

9. Enable consolidated prompts

10. Set refresh settings for objects

11. Set parameter binding

12. Take a snapshot

13. Save Live Office documents to the repository

14. Open and view Live Office documents from the repository

1. Understanding BO-SAP Integration kit

2. Configuring single sign on authentication

3. Creating SAP Authentication in BO

4. Importing the roles of SAP into BO

5. Entitlement settings of SAP & BO System

1. Creation of Web intelligence reports using Info cube & BW Query

1. Creating Polestar Reports

2. Configuring Pole star with BO System

1. Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI

2. Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI

1. Creation of Universe from scratch (SalesDomain Domain)

2. Creation of Web intelligence report with auto scheduling

3. Creation of Corporate dashboard for Supply chain mgmt/Banking Domain